-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 07, 2012 at 05:07 PM
-- Server version: 5.1.41
-- PHP Version: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `HBMS`
--

-- --------------------------------------------------------

--
-- Table structure for table `tbl_components`
--

DROP TABLE IF EXISTS `tbl_components`;
CREATE TABLE IF NOT EXISTS `tbl_components` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `component_name` varchar(100) NOT NULL,
  `device_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=57 ;

--
-- Dumping data for table `tbl_components`
--

INSERT INTO `tbl_components` (`id`, `component_name`, `device_id`) VALUES
(1, 'CPUH', 1),
(2, 'CPUV', 1),
(3, 'Displays', 1),
(4, 'HVAC', 1),
(5, 'CPUH', 2),
(6, 'CPUV', 2),
(7, 'Displays', 2),
(8, 'HVAC', 2),
(9, 'CPUH', 3),
(10, 'CPUV', 3),
(11, 'Displays', 3),
(12, 'HVAC', 3),
(13, 'CPUH', 4),
(14, 'CPUV', 4),
(15, 'Displays', 4),
(16, 'HVAC', 4),
(17, 'CPUH', 5),
(18, 'CPUV', 5),
(19, 'Displays', 5),
(20, 'HVAC', 5),
(21, 'CPUH', 6),
(22, 'CPUV', 6),
(23, 'Displays', 6),
(24, 'HVAC', 6),
(25, 'CPUH', 7),
(26, 'CPUV', 7),
(27, 'Displays', 7),
(28, 'HVAC', 7),
(29, 'CPUH', 8),
(30, 'CPUV', 8),
(31, 'Displays', 8),
(32, 'HVAC', 8),
(33, 'CPUH', 9),
(34, 'CPUV', 9),
(35, 'Displays', 9),
(36, 'HVAC', 9),
(37, 'CPUH', 10),
(38, 'CPUV', 10),
(39, 'Displays', 10),
(40, 'HVAC', 10),
(41, 'CPUH', 11),
(42, 'CPUV', 11),
(43, 'Displays', 11),
(44, 'HVAC', 11),
(45, 'CPUH', 12),
(46, 'CPUV', 12),
(47, 'Displays', 12),
(48, 'HVAC', 12),
(49, 'CPUH', 13),
(50, 'CPUV', 13),
(51, 'Displays', 13),
(52, 'HVAC', 13),
(53, 'CPUH', 14),
(54, 'CPUV', 14),
(55, 'Displays', 14),
(56, 'HVAC', 14);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_component_cpu`
--

DROP TABLE IF EXISTS `tbl_component_cpu`;
CREATE TABLE IF NOT EXISTS `tbl_component_cpu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `component_id` int(11) NOT NULL,
  `component_type` int(2) NOT NULL,
  `cpu_name` varchar(255) NOT NULL,
  `ip_address` varchar(255) NOT NULL,
  `last_ping` datetime NOT NULL,
  `current_status` varchar(50) NOT NULL,
  `cpu_temp` varchar(50) NOT NULL,
  `network_speed` varchar(50) NOT NULL,
  `os_version` varchar(50) NOT NULL,
  `player_vers` varchar(50) NOT NULL,
  `last_reboot` varchar(50) NOT NULL,
  `free_hd_space` varchar(255) NOT NULL,
  `schedule_name` varchar(50) NOT NULL,
  `last_sched_upload` varchar(50) NOT NULL,
  `schedule_file_size` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=105 ;

--
-- Dumping data for table `tbl_component_cpu`
--

INSERT INTO `tbl_component_cpu` (`id`, `component_id`, `component_type`, `cpu_name`, `ip_address`, `last_ping`, `current_status`, `cpu_temp`, `network_speed`, `os_version`, `player_vers`, `last_reboot`, `free_hd_space`, `schedule_name`, `last_sched_upload`, `schedule_file_size`) VALUES
(1, 1, 0, 'CPU007', '123.142.0.2', '10:52:00', 'online', '83oF', '.2Mbps', '10.7.1', '2.8.1', '12:04a 01/15/12', '132Gb', '"SCHED123"', '12:30a 01/03/12', '9.2Gb'),
(35, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'online', '', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(36, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'online', '83oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(40, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', '', '83oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(43, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '83oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(44, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '83oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(45, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '45oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(46, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'online', '45oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(47, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'online', '45oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(48, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'online', '105oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(49, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'online', '45oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(50, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '45oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(51, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '83oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(53, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '83oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(54, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(55, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(56, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(57, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(58, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(59, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(60, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(61, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(62, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(63, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(64, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(65, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(66, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(67, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(68, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(69, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(70, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(71, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(72, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(73, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(74, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(75, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(76, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(77, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(78, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(79, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(80, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(81, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(82, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(83, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(84, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(85, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(86, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(87, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(88, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(89, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(90, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'offline', '95oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '', 'SCHED123', '12:30', ''),
(101, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', '', '83oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '132Gb', 'SCHED123', '12:30', '9.2Gb'),
(102, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', '', '83oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '132Gb', 'SCHED123', '12:30', '9.2'),
(103, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'online', '83oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '132Gb', 'SCHED00123', '12:30', '9.2'),
(104, 63, 2, 'CPU009', '123.142.0.2', '10:52:00', 'online', '83oF', '2Mbps', '10.7.1', '2.8.1', '12:04', '132Gb', 'SCHED00123', '12:30', '9.2Gb');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_component_display`
--

DROP TABLE IF EXISTS `tbl_component_display`;
CREATE TABLE IF NOT EXISTS `tbl_component_display` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `component_id` int(11) NOT NULL,
  `display_type` int(2) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `ip_address` varchar(255) NOT NULL,
  `last_ping` datetime NOT NULL,
  `current_status` varchar(50) NOT NULL,
  `display_temp` varchar(50) NOT NULL,
  `backlight_temp` varchar(50) NOT NULL,
  `ctrl_board_temp` varchar(50) NOT NULL,
  `duty_cycle` int(11) NOT NULL,
  `ambient_light` int(11) NOT NULL,
  `brightness` int(11) NOT NULL,
  `input_source` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `tbl_component_display`
--

INSERT INTO `tbl_component_display` (`id`, `component_id`, `display_type`, `display_name`, `ip_address`, `last_ping`, `current_status`, `display_temp`, `backlight_temp`, `ctrl_board_temp`, `duty_cycle`, `ambient_light`, `brightness`, `input_source`) VALUES
(1, 3, 0, 'Upper Left Horiz - 07ULH', '123.142.0.2', '10:52:00', 'online', '102oF', '80oF', '89oF', 23, 83, 40, 'DVI1'),
(2, 3, 1, 'Upper Right Horiz - 07ULH', '123.142.0.2', '10:52:00', 'online', '102oF', '80oF', '89oF', 23, 83, 40, 'DVI1'),
(3, 3, 2, 'Bottom Left Horiz - 07ULH', '123.142.0.2', '10:52:00', 'online', '102oF', '80oF', '89oF', 23, 83, 40, 'DVI1'),
(4, 3, 3, 'Bottom Right Horiz - 07ULH', '123.142.0.2', '10:52:00', 'online', '102oF', '80oF', '89oF', 23, 83, 40, 'DVI1'),
(5, 3, 4, 'Upper Left Horiz - 07ULH', '123.142.0.2', '10:52:00', 'online', '102oF', '80oF', '89oF', 23, 83, 40, 'DVI1'),
(6, 9, 3, 'Upper Left Horiz - 07ULH', '123.142.0.2', '10:52:00', 'online', '83oF', '102oF', '89oF', 23, 83, 40, 'DVI1'),
(7, 9, 3, 'Upper Left Horiz - 07ULH', '123.142.0.2', '10:52:00', 'online', '83oF', '102oF', '89oF', 23, 83, 40, 'DVI1'),
(8, 9, 3, 'Upper Left Horiz - 07ULH', '123.142.0.2', '10:52:00', 'online', '83 oF', '102 oF', '89 oF', 23, 83, 40, 'DVI1'),
(9, 9, 3, 'Upper Left Horiz - 07ULH', '123.142.0.2', '10:52:00', 'online', '83 oF', '102 oF', '89 oF', 23, 83, 40, 'DVI1'),
(10, 9, 3, 'Upper Left Horiz - 07ULH', '123.142.0.2', '10:52:00', 'online', '83 oF', '102 oF', '89 oF', 23, 83, 40, 'DVI1'),
(11, 9, 3, 'Upper Left Horiz - 07ULH', '123.142.0.2', '10:52:00', 'online', '83 oF', '102 oF', '89 oF', 23, 83, 40, 'DVI1'),
(12, 9, 3, 'Upper Left Horiz - 07ULH', '123.142.0.2', '10:52:00', 'online', '83 oF', '102 oF', '89 oF', 23, 83, 40, 'DVI1'),
(13, 9, 3, 'Upper Left Horiz - 07ULH', '123.142.0.2', '10:52:00', 'online', '83 oF', '102 oF', '89 oF', 23, 83, 40, 'DVI1'),
(14, 9, 3, 'Upper Left Horiz - 07ULH', '123.142.0.2', '10:52:00', 'online', '83 oF', '102 oF', '89 oF', 23, 83, 40, 'DVI1');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_component_hvac`
--

DROP TABLE IF EXISTS `tbl_component_hvac`;
CREATE TABLE IF NOT EXISTS `tbl_component_hvac` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `component_id` int(11) NOT NULL,
  `hvac_unit_name` varchar(255) NOT NULL,
  `controller_firmware_ver` varchar(255) NOT NULL,
  `ac_status` varchar(255) NOT NULL,
  `heater_status` varchar(255) NOT NULL,
  `water_present` varchar(255) NOT NULL,
  `inside_temp` varchar(255) NOT NULL,
  `outside_temp` varchar(50) NOT NULL,
  `inside_humidity` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `tbl_component_hvac`
--

INSERT INTO `tbl_component_hvac` (`id`, `component_id`, `hvac_unit_name`, `controller_firmware_ver`, `ac_status`, `heater_status`, `water_present`, `inside_temp`, `outside_temp`, `inside_humidity`) VALUES
(5, 9, 'HVAC003', '1.2.3', 'on', 'on', 'yes', '83o', '83o', ''),
(4, 4, 'HVAC003', '1.2.3', 'on', 'on', 'yes', '83o', '83o', '10%'),
(6, 9, 'HVAC003', '1.2.3', 'on', 'on', 'yes', '83o', '83o', ''),
(7, 9, 'HVAC003', '1.2.3', 'on', 'on', 'yes', '83o', '83o', ''),
(8, 9, 'HVAC003', '1.2.3', 'on', 'on', 'yes', '83o', '83', '10%'),
(9, 9, 'HVAC003', '1.2.3', 'on', 'on', 'yes', '83ooF', '83oF', '10%'),
(10, 9, 'HVAC003', '1.2.3', 'on', 'on', 'no', '83ooF', '83oF', '10%'),
(11, 9, 'HVAC003', '1.2.3', 'on', 'on', 'yes', '83oF', '83oF', '10%'),
(12, 9, 'HVAC003', '1.2.3', 'on', 'on', 'yes', '83oF', '83oF', '10%'),
(13, 9, 'HVAC003', '1.2.3', 'on', 'on', 'yes', '83oF', '83oF', '30');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_component_state`
--

DROP TABLE IF EXISTS `tbl_component_state`;
CREATE TABLE IF NOT EXISTS `tbl_component_state` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `component_id` int(11) NOT NULL,
  `state` enum('green','yellow','red','blue') NOT NULL,
  `datetime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=128 ;

--
-- Dumping data for table `tbl_component_state`
--

INSERT INTO `tbl_component_state` (`id`, `component_id`, `state`, `datetime`) VALUES
(1, 1, 'yellow', '2012-02-28 17:30:07'),
(2, 1, 'yellow', '2012-02-28 17:35:19'),
(3, 1, 'red', '2012-02-28 17:40:07'),
(4, 1, 'blue', '2012-02-28 17:45:19'),
(5, 1, 'green', '2012-02-28 17:50:30'),
(6, 2, 'yellow', '2012-02-28 17:55:19'),
(7, 2, 'blue', '0000-00-00 00:00:00'),
(8, 2, 'red', '0000-00-00 00:00:00'),
(9, 2, 'blue', '0000-00-00 00:00:00'),
(10, 3, 'red', '2012-02-28 17:50:30'),
(11, 3, 'yellow', '2012-02-28 17:55:19'),
(12, 3, 'yellow', '0000-00-00 00:00:00'),
(13, 4, 'red', '2012-02-28 18:05:15'),
(14, 4, 'blue', '2012-02-28 18:10:28'),
(15, 5, 'green', '2012-02-28 18:50:39'),
(16, 5, 'green', '2012-02-28 18:55:19'),
(17, 5, 'red', '0000-00-00 00:00:00'),
(18, 5, 'yellow', '2012-02-28 19:05:19'),
(19, 5, 'blue', '2012-02-28 19:10:19'),
(20, 5, 'red', '2012-02-28 19:15:19'),
(21, 5, 'red', '2012-02-28 19:20:19'),
(22, 5, 'red', '2012-02-28 19:25:19'),
(23, 5, 'yellow', '2012-02-28 19:30:19'),
(24, 5, 'blue', '2012-02-28 19:35:19'),
(25, 5, 'green', '2012-02-28 18:50:39'),
(26, 5, 'green', '2012-02-28 18:55:19'),
(27, 5, 'red', '0000-00-00 00:00:00'),
(28, 5, 'yellow', '2012-02-28 19:05:19'),
(29, 7, 'red', '2012-02-28 19:10:19'),
(30, 7, 'blue', '2012-02-28 19:15:19'),
(31, 6, 'red', '2012-02-28 19:20:19'),
(32, 6, 'yellow', '2012-02-28 19:25:19'),
(33, 8, 'red', '2012-02-28 19:30:19'),
(34, 8, 'yellow', '2012-02-28 19:35:19'),
(35, 1, 'green', '2012-02-28 17:50:32'),
(36, 1, 'yellow', '2012-02-28 17:50:36'),
(37, 1, 'red', '2012-02-28 17:50:40'),
(38, 1, 'blue', '2012-02-28 17:50:50'),
(39, 1, 'green', '2012-02-28 17:50:55'),
(40, 1, 'red', '2012-02-29 17:57:56'),
(41, 1, 'blue', '2012-02-29 17:58:10'),
(42, 2, 'blue', '2012-03-05 19:03:09'),
(43, 44, 'red', '2012-03-05 19:15:09'),
(44, 63, 'red', '2012-03-06 06:46:12'),
(45, 63, 'red', '2012-03-06 06:48:27'),
(46, 63, 'red', '2012-03-06 06:48:43'),
(47, 63, 'red', '2012-03-06 06:48:56'),
(48, 63, 'red', '2012-03-06 06:51:39'),
(49, 63, 'green', '2012-03-06 06:51:55'),
(50, 63, 'green', '2012-03-06 06:52:33'),
(51, 63, 'green', '2012-03-06 06:52:46'),
(52, 63, 'green', '2012-03-06 06:54:06'),
(53, 63, 'red', '2012-03-06 06:54:08'),
(54, 63, 'red', '2012-03-06 06:54:08'),
(55, 63, 'red', '2012-03-06 06:54:08'),
(56, 44, 'red', '2012-03-05 19:15:09'),
(57, 9, 'green', '2012-03-06 07:26:34'),
(58, 9, 'green', '2012-03-06 07:28:41'),
(59, 9, 'green', '2012-03-06 07:28:42'),
(60, 9, 'green', '2012-03-06 07:28:43'),
(61, 9, 'green', '2012-03-06 07:28:43'),
(62, 9, 'green', '2012-03-06 07:28:43'),
(63, 63, 'red', '2012-03-06 07:33:09'),
(64, 63, 'red', '2012-03-06 07:34:18'),
(65, 63, 'red', '2012-03-06 07:35:55'),
(66, 63, 'red', '2012-03-06 07:37:00'),
(67, 63, 'red', '2012-03-06 07:37:04'),
(68, 63, 'red', '2012-03-06 07:37:28'),
(69, 63, 'red', '2012-03-06 07:37:48'),
(70, 63, 'red', '2012-03-06 07:37:49'),
(71, 63, 'red', '2012-03-06 07:37:49'),
(72, 63, 'red', '2012-03-06 07:37:49'),
(73, 63, 'red', '2012-03-06 07:37:50'),
(74, 63, 'red', '2012-03-06 07:37:50'),
(75, 63, 'red', '2012-03-06 07:37:50'),
(76, 63, 'red', '2012-03-06 07:37:50'),
(77, 63, 'red', '2012-03-06 07:38:10'),
(78, 63, 'red', '2012-03-06 07:38:11'),
(79, 63, 'red', '2012-03-06 07:38:12'),
(80, 63, 'red', '2012-03-06 07:38:12'),
(81, 63, 'red', '2012-03-06 07:38:13'),
(82, 63, 'red', '2012-03-06 07:38:13'),
(83, 63, 'red', '2012-03-06 07:38:13'),
(84, 63, 'red', '2012-03-06 07:38:47'),
(85, 63, 'red', '2012-03-06 07:38:48'),
(86, 63, 'red', '2012-03-06 07:38:49'),
(87, 63, 'red', '2012-03-06 07:38:49'),
(88, 63, 'red', '2012-03-06 07:38:50'),
(89, 63, 'red', '2012-03-06 07:39:03'),
(90, 63, 'red', '2012-03-06 07:39:04'),
(91, 63, 'red', '2012-03-06 07:39:04'),
(92, 63, 'red', '2012-03-06 07:39:04'),
(93, 63, 'red', '2012-03-06 07:39:05'),
(94, 63, 'red', '2012-03-06 07:39:21'),
(95, 63, 'red', '2012-03-06 07:39:37'),
(96, 63, 'red', '2012-03-06 07:39:38'),
(97, 63, 'red', '2012-03-06 07:39:38'),
(98, 63, 'red', '2012-03-06 07:39:39'),
(99, 63, 'red', '2012-03-06 07:39:39'),
(100, 63, 'red', '2012-03-06 07:39:39'),
(101, 63, 'red', '2012-03-06 07:41:39'),
(102, 63, 'red', '2012-03-06 07:42:32'),
(103, 63, 'red', '2012-03-06 07:42:47'),
(104, 1, 'red', '2012-03-06 08:09:33'),
(105, 63, 'red', '2012-03-06 08:09:37'),
(106, 63, 'red', '2012-03-07 11:00:56'),
(107, 9, 'yellow', '2012-03-07 11:00:57'),
(108, 9, 'green', '2012-03-07 11:00:57'),
(109, 9, 'green', '2012-03-07 11:00:57'),
(110, 63, 'green', '2012-03-07 11:00:58'),
(111, 63, 'yellow', '2012-03-07 11:00:58'),
(112, 63, 'green', '2012-03-07 11:00:59'),
(113, 63, 'green', '2012-03-07 11:00:59'),
(114, 63, 'red', '2012-03-07 11:00:59'),
(115, 9, 'green', '2012-03-07 11:39:39'),
(116, 9, 'green', '2012-03-07 12:20:52'),
(117, 9, 'green', '2012-03-07 12:26:23'),
(118, 63, 'red', '2012-03-07 02:20:31'),
(119, 63, 'red', '2012-03-07 02:21:28'),
(120, 63, 'yellow', '2012-03-07 02:22:16'),
(121, 63, 'yellow', '2012-03-07 02:23:09'),
(122, 9, 'yellow', '2012-03-07 02:26:30'),
(123, 9, 'yellow', '2012-03-07 02:27:36'),
(124, 9, 'green', '2012-03-07 02:28:03'),
(125, 9, 'yellow', '2012-03-07 04:33:54'),
(126, 9, 'yellow', '2012-03-07 04:34:36'),
(127, 9, 'yellow', '2012-03-07 04:36:37');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_device`
--

DROP TABLE IF EXISTS `tbl_device`;
CREATE TABLE IF NOT EXISTS `tbl_device` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `device_name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `tbl_device`
--

INSERT INTO `tbl_device` (`id`, `device_name`) VALUES
(1, 'u01 47 / Bway'),
(2, 'u01 47 / Bway'),
(3, 'u01 47 / Bway'),
(4, 'u01 47 / Bway'),
(5, 'u01 47 / Bway'),
(6, 'u01 47 / Bway'),
(7, 'u01 47 / Bway'),
(8, 'u01 47 / Bway'),
(9, 'u01 47 / Bway'),
(10, 'u01 47 / Bway'),
(11, 'u01 47 / Bway'),
(12, 'u01 47 / Bway'),
(13, 'u01 47 / Bway'),
(14, 'u01 47 / Bway');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_log_message`
--

DROP TABLE IF EXISTS `tbl_log_message`;
CREATE TABLE IF NOT EXISTS `tbl_log_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `component_id` int(11) NOT NULL,
  `created_date` datetime NOT NULL,
  `message` varchar(255) NOT NULL,
  `status` tinyint(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `tbl_log_message`
--

INSERT INTO `tbl_log_message` (`id`, `component_id`, `created_date`, `message`, `status`) VALUES
(2, 1, '2012-02-27 19:47:20', 'temperature 105', 3),
(3, 1, '2012-02-27 19:47:25', 'temperature in range', 1),
(4, 1, '2012-02-27 19:53:37', 'shut down', 0),
(5, 1, '2012-02-27 19:54:16', 'power on', 0),
(6, 5, '2012-02-27 19:47:20', 'temperature 105', 3),
(7, 5, '2012-02-27 19:55:00', 'temperature in range', 1),
(8, 5, '2012-02-27 19:55:17', 'shut down', 0),
(9, 5, '2012-02-27 19:55:32', 'power on', 0),
(10, 9, '2012-02-27 19:55:50', 'temperature 105', 3),
(11, 9, '2012-02-27 19:56:04', 'temperature in range', 1),
(12, 9, '2012-02-27 19:56:22', 'shut down', 0),
(13, 9, '2012-02-27 19:47:25', 'power on', 0);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_users`
--

DROP TABLE IF EXISTS `tbl_users`;
CREATE TABLE IF NOT EXISTS `tbl_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `last_login_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_users`
--

INSERT INTO `tbl_users` (`id`, `username`, `password`, `email`, `display_name`, `last_login_date`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin@admin.com', 'super user', '2012-02-25 12:06:30'),
(2, 'test', '098f6bcd4621d373cade4e832627b4f6', 'test@test.com', 'test user', '0000-00-00 00:00:00');
